House Price Prediction with Bayesian Model Averaging

Exploratory Data Analysis

Univariate Analysis

Continuous Variables

Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
PID 0 0 713844613 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
area 17 2.04 1450 1419
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
price 40 4.8 174622 163947
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
MS.SubClass 64 7.67 57.9 48.6
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Lot.Frontage 24 2.88 NA NA
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Lot.Area 32 3.84 10228 9064
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Lot.Shape 2 0.24 3.59 3.6
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Utilities 0 0 4 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Land.Slope 34 4.08 2.96 3
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Overall.Qual 1 0.12 6 6
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Overall.Cond 70 8.39 5.64 5.51
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Year.Built 4 0.48 1970 1970
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Year.Remod.Add 0 0 1983 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Mas.Vnr.Area 66 7.91 NA NA
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Exter.Qual 0 0 3.36 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Exter.Cond 123 14.8 3.11 3
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bsmt.Qual 21 2.52 3.44 3.53
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bsmt.Cond 71 8.51 2.94 3
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bsmt.Exposure 75 8.99 1.64 1.4
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
BsmtFin.Type.1 0 0 3.64 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
BsmtFin.SF.1 2 0.24 453 449
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
BsmtFin.Type.2 123 14.8 1.3 1
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
BsmtFin.SF.2 103 12.3 52.4 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bsmt.Unf.SF 18 2.16 518 490
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Total.Bsmt.SF 39 4.68 1023 1022
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Heating.QC 0 0 4.13 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Electrical 58 6.95 4.91 5
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
X1st.Flr.SF 14 1.68 1127 1108
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
X2nd.Flr.SF 1 0.12 318 316
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Low.Qual.Fin.SF 10 1.2 4.52 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bsmt.Full.Bath 0 0 0.44 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bsmt.Half.Bath 50 6 0.06 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Full.Bath 2 0.24 1.5 1.5
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Half.Bath 0 0 0.38 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bedroom.AbvGr 19 2.28 2.81 2.76
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Kitchen.AbvGr 32 3.84 1.04 1
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Kitchen.Qual 1 0.12 3.47 3.47
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
TotRms.AbvGrd 10 1.2 6.27 6.21
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Functional 57 6.83 7.85 8
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Fireplaces 3 0.36 0.59 0.58
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Fireplace.Qu 0 0 1.67 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Garage.Yr.Blt 7 0.84 1974 1975
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Garage.Finish 185 22.2 1.12 0.59
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Garage.Cars 7 0.84 1.72 1.7
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Garage.Area 9 1.08 461 454
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Garage.Qual 77 9.23 2.83 3
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Garage.Cond 66 7.91 2.84 3
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Paved.Drive 89 10.7 2.82 3
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Wood.Deck.SF 21 2.52 93.2 81.9
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Open.Porch.SF 39 4.68 45.3 35.9
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Enclosed.Porch 143 17.1 24 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
X3Ssn.Porch 12 1.44 3.19 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Screen.Porch 66 7.91 14.9 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Pool.Area 3 0.36 1.75 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Pool.QC 3 0.36 0.01 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Fence 179 21.5 0.65 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Misc.Val 28 3.36 53.1 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Mo.Sold 0 0 6.16 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Yr.Sold 0 0 2008 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
age 4 0.48 48 47.6
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
age.remod 0 0 35 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
age.garage 7 0.84 43.6 42.9
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
area.log 4 0.48 7.22 7.23
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
age.garage.log 0 0 3.61 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
price.log 21 2.52 12 12
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Lot.Area.log 72 8.63 9.08 9.13
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Overall.Qual.log 6 0.72 1.93 1.93
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Overall.Cond.log 70 8.39 1.88 1.87
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Year.Built.log 7 0.84 7.59 7.59
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Year.Remod.Add.log 0 0 7.59 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
BsmtFin.SF.1.log 0 0 4.44 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bsmt.Unf.SF.log 74 8.87 5.56 6.08
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Total.Bsmt.SF.log 38 4.56 6.73 6.91
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
X1st.Flr.SF.log 4 0.48 6.98 6.98
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
X2nd.Flr.SF.log 0 0 2.68 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bsmt.Full.Bath.log 0 0 0.3 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bsmt.Half.Bath.log 50 6 0.04 0
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Full.Bath.log 2 0.24 0.9 0.9
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Half.Bath.log 0 0 0.26 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Bedroom.AbvGr.log 6 0.72 1.31 1.31
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Kitchen.AbvGr.log 32 3.84 0.71 0.69
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
TotRms.AbvGrd.log 5 0.6 1.96 1.96
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Fireplaces.log 0 0 0.38 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Garage.Yr.Blt.log 7 0.84 7.59 7.59
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Garage.Cars.log 36 4.32 0.96 1
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Garage.Area.log 36 4.32 5.85 6.11
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Wood.Deck.SF.log 0 0 2.43 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Open.Porch.SF.log 0 0 2.3 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Mo.Sold.log 71 8.51 1.89 1.98
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
Yr.Sold.log 0 0 7.61 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
age.log 0 0 3.69 NaN
Term Outliers Outlier Pct Mean with Outliers Mean w/o Outliers
age.remod.log 0 0 3.41 NaN

Categorical Variables

Other RL Total
Frequency 178 656 834
Proportion 0.213 0.787 1.000
Grvl Pave Total
Frequency 2 832 834
Proportion 0.0024 0.9976 1.0000
Grvl Pave Total
Frequency 28 25 53
Proportion 0.0336 0.0300 0.0635
Bnk HLS Low Lvl Total
Frequency 29 29 19 757 834
Proportion 0.0348 0.0348 0.0228 0.9077 1.0000
Corner CulDSac FR Inside Total
Frequency 145 63 36 590 834
Proportion 0.1739 0.0755 0.0432 0.7074 1.0000
Blmngtn Other BrDale BrkSide ClearCr CollgCr Crawfor Edwards Gilbert IDOTRR MeadowV Mitchel NAmes NoRidge NridgHt NWAmes OldTown Sawyer SawyerW Somerst StoneBr SWISU Timber Veenker Total
Frequency 7 13 7 36 11 75 25 50 36 27 16 41 140 28 36 35 62 57 39 45 12 10 17 9 834
Proportion 0.00839 0.01559 0.00839 0.04317 0.01319 0.08993 0.02998 0.05995 0.04317 0.03237 0.01918 0.04916 0.16787 0.03357 0.04317 0.04197 0.07434 0.06835 0.04676 0.05396 0.01439 0.01199 0.02038 0.01079 1.00000
Artery Feedr Norm PosA PosN RRAe RRAn RRNe RRNn Total
Frequency 19 46 732 7 9 8 9 2 2 834
Proportion 0.02278 0.05516 0.87770 0.00839 0.01079 0.00959 0.01079 0.00240 0.00240 1.00000
Artery Feedr Norm PosN RRNn Total
Frequency 1 6 825 1 1 834
Proportion 0.00120 0.00719 0.98921 0.00120 0.00120 1.00000
1Fam Other Total
Frequency 687 147 834
Proportion 0.824 0.176 1.000
1.5Fin Other 1Story 2Story SFoyer SLvl Total
Frequency 85 18 422 239 32 38 834
Proportion 0.1019 0.0216 0.5060 0.2866 0.0384 0.0456 1.0000
Other Gable Total
Frequency 180 654 834
Proportion 0.216 0.784 1.000
CompShg Metal Tar&Grv WdShake WdShngl Total
Frequency 822 1 8 1 2 834
Proportion 0.98561 0.00120 0.00959 0.00120 0.00240 1.00000
Other BrkFace CemntBd HdBoard MetalSd Plywood VinylSd Wd Sdng Total
Frequency 44 32 30 145 130 66 262 125 834
Proportion 0.0528 0.0384 0.0360 0.1739 0.1559 0.0791 0.3141 0.1499 1.0000
Other BrkFace HdBoard MetalSd Plywood VinylSd Wd Sdng Total
Frequency 85 20 134 132 85 259 119 834
Proportion 0.102 0.024 0.161 0.158 0.102 0.311 0.143 1.000
Other BrkFace None Total
Frequency 55 263 516 834
Proportion 0.0659 0.3153 0.6187 1.0000
Other CBlock PConc Total
Frequency 102 381 351 834
Proportion 0.122 0.457 0.421 1.000
GasA GasW Grav OthW Wall Total
Frequency 824 7 1 1 1 834
Proportion 0.98801 0.00839 0.00120 0.00120 0.00120 1.00000
N Y Total
Frequency 45 789 834
Proportion 0.054 0.946 1.000
Other Attchd BuiltIn Detchd Total
Frequency 17 505 43 234 799
Proportion 0.0204 0.6055 0.0516 0.2806 0.9580
Gar2 Othr Shed TenC Total
Frequency 2 1 24 1 28
Proportion 0.0024 0.0012 0.0288 0.0012 0.0336
COD Con ConLD ConLI ConLw CWD Oth VWD WD Total
Frequency 16 4 5 3 5 2 1 1 797 834
Proportion 0.0192 0.0048 0.0060 0.0036 0.0060 0.0024 0.0012 0.0012 0.9556 1.0000
Normal Total
Frequency 834 834
Proportion 1 1

2018-08-06